from tortoise.expressions import Q
from app.core.crud import CRUDBase
from app.models.saas import Buckling
from app.schemas.saas import BucklingCreate, BucklingUpdate


class BucklingController(CRUDBase[Buckling, BucklingCreate, BucklingUpdate]):
    def __init__(self):
        super().__init__(model=Buckling)

    async def do_list(self, page: int, page_size: int, search: Q = Q()):
        query = self.model.filter(search)
        total = await query.count()
        objs = await query.offset((page - 1) * page_size).limit(page_size).order_by('-id')
        data = [await obj.to_dict(exclude_fields=["updated_at","deleted_at"]) for obj in objs]
        return total, data

    async def do_detail(self,data_id:int):
        obj = await self.get(id=data_id)
        data = await obj.to_dict()
        return data

    async def do_create(self, obj_in: BucklingCreate):
        await self.create(obj_in=obj_in)
        return True

    async def do_update(self, obj_in: BucklingUpdate):
        await self.update(id=obj_in.id, obj_in=obj_in)
        return True

    async def do_delete(self, data_id: int):
        await self.remove(id=data_id)
        return True



buckling_controller = BucklingController()
